FORECAST_ETS_CONFINT
Returns a confidence interval for the forecast value at the specified target date.
Syntax
expression.FORECAST_ETS_CONFINT(arg1, arg2, arg3, arg4, arg5, arg6, arg7);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number |
| arg2 | Required | ApiRange | ApiName | number[] |
| arg3 | Required | ApiRange | ApiName | |
| arg4 | Required | ApiRange | ApiName | number |
| arg5 | Required | ApiRange | ApiName | number |
| arg6 | Required | ApiRange | ApiName | number |
| arg7 | Required | ApiRange | ApiName | number |
Returns
number
Example
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var dates = ["10/1/2017", "11/1/2017", "12/1/2017", "1/1/2018", "2/1/2018", "3/1/2018"];
var numbers = [12558, 14356, 16345, 18678, 14227];
for (var i = 0; i < dates.length; i++) {
oWorksheet.GetRange("A" + (i + 1)).SetValue(dates[i]);
}
for (var j = 0; j < numbers.length; j++) {
oWorksheet.GetRange("B" + (j + 1)).SetValue(numbers[j]);
}
var oRange1 = oWorksheet.GetRange("B1:B5");
var oRange2 = oWorksheet.GetRange("A1:A5");
oWorksheet.GetRange("B6").SetValue(oFunction.FORECAST_ETS_CONFINT("3/1/2018", oRange1, oRange2, 0.95, 1, 1, 1));